ADRC Database Available Variables

ADRC Databse Available Data and Dictionary

Download Dictionary:
ADRC Database Available Variables

Variable / Field Name Field Label Choices, Calculations, OR Slider Labels
deceased_status Deceased status 1, Yes
adrc_study_id ADRC study ID
scmd_study_id SCMD Study ID
udall_study_id Udall study ID
leads_study_id LEADS Study ID
acad_study_id ACAD Study ID
study_tracking_notes Study Tracking Notes
coviddone COVID Vaccination Documentation Have you received one or more doses of the COVID vaccine?
covid1st When did you receive your first dose?
covid2nd When did you receive your second dose?
covidboost Booster Shot
covidboost_2 Second Booster Shot
age(enrollment) Age (years)
ethnicity Ethnicity 1, Hispanic or Latino | 0, NOT Hispanic or Latino | 99, Unknown / Not Reported
ethnicity_origin If yes, what is the origin?
race Race 0, American Indian/Alaska Native | 1, Asian | 2, Native Hawaiian or Other Pacific Islander | 3, Black or African American | 4, White | 5, More Than One Race | 99, Unknown / Not Reported
race_additional Additional Race
primary_lang Primary Language 1, English | 2, Spanish | 3, Mandarin | 4, Cantonese | 5, Russian | 6, Japanese | 8, Other primary language (SPECIFY)
primary_lang_specify Primary Language SPECIFY
sex Sex 0, female | 1, male | 99, other
handedness Handedness 0, left | 1, right | 2, ambidextrous
education_yrs Years of education completed
date_visit Date of visit
visit_ty Type of visit 1, 1 Initial Visit Packet (IVP) | 2, 2 Follow Visit Packet (FVP) | 3, 3 Telephone Follow-up Packet (TFP)
contact_agreement Agree to be contacted for other research? 1, Yes | 0, No
oth_trial Is the participant currently in a clinical/drug study? 1, Yes | 0, No
if_yes_trial_su Is the clinical/drug trial at Stanford?? 1, Yes | 0, No
no_su_trial Where is the clinical/drug trial being conducted?
yes_oth_trial What is the name of the study or/and drug or/and type of drug or what intervention is studied?
oth_study Is the participant is currently on in another study (not clinical/drug trial)? 1, Yes | 0, No
if_yes_study_su Is the study being conducted at Stanford? 1, Yes | 0, No
no_su_study Where is the study being conducted?
yes_oth_study What is being studied or name of study
age_at_visit Age in years
height_at_visit Height (cm)
weight_at_visit weight (kilograms)
bmi_at_visit BMI round(([weight_at_visit]*10000)/(([height_at_visit])^(2)),1)
primary_dgn_prelim_cat Primary Diagnosis (preliminary) 0, Healthy Control | 1, Mild Cognitive Impairment | 2, Probable Alzheimer's Disease | 3, Possible Alzheimer's Disease | 4, Lewy Body Disease | 5, Parkinson's Disease only | 6, Parkinson's Disease and Mild cognitive impairment | 7, Parkinson's Disease and Dementia | 8, Other | 9, w/Concerns | 99, unknown
primary_dgn_prelim_concerns Concerns (preliminary) 1, Language | 2, Attention | 3, Executive | 4, Visuospatial | 5, Memory | 99, Other
primary_dgn_prelim Notes on Primary Diagnosis (preliminary)
primary_dgn_consensus Primary Diagnosis (consensus) 0, Healthy Control | 1, Mild Cognitive Impairment | 2, Probable Alzheimer's Disease | 3, Possible Alzheimer's Disease | 4, Lewy Body Disease | 5, Parkinson's Disease only | 6, Parkinson's Disease and Mild cognitive impairment | 7, Parkinson's Disease and Dementia | 8, Other | 9, w/Concerns | 99, unknown
secondary_dgn_consensus Secondary Diagnosis (consensus)
primary_dgn_consensus_concerns_2 Concerns (consensus) 1, Language | 2, Attention | 3, Executive | 4, Visuospatial | 5, Memory | 6, Mood/Behavior | 99, Other
date_dgn Date of Diagnosis (consensus)
notes_dgn Notes on Diagnosis
study_consent_form_1 Study Consent Form 1 1, Healthy Brain Aging Study | 2, Pacific Udall Center Study | 3, Consent for Study Partner | 4, ADRC eConsent form | 5, ADRC Spanish eConsent form | 6, PUC eConsent form | 10, ADRC eConsent | 20, ADRC Spanish eConsent | 30, LB-SPARK eConsent form | 40, LB-SPARK Spanish eConsent form
date_of_consent_1 Date of consent
consent_form_1 upload consent form
study_consent_form_2 Study Consent Form 2 1, Healthy Brain Aging Study | 2, Pacific Udall Center Study | 3, Consent for Study Partner | 4, ADRC eConsent form | 5, ADRC Spanish eConsent form | 6, PUC eConsent form | 10, ADRC eConsent | 20, ADRC Spanish eConsent | 30, LB-SPARK eConsent form | 40, LB-SPARK Spanish eConsent form
date_of_consent_2 Date of Consent
consent_form_2 Upload consent form
study_consent_form_3 Study Partner Consent 1 1, Healthy Brain Aging Study | 2, Pacific Udall Center Study | 3, Consent for Study Partner | 4, ADRC eConsent form | 5, ADRC Spanish eConsent form | 6, PUC eConsent form | 10, ADRC Study Partner eConsent | 20, LB-SPARK Study Partner eConsent | 30, LB-SPARK Spanish Study Partner eConsent
date_of_consent_3 Date of Consent
brain_donation_consent Brain Donation/Autopsy Consent 1, Brain Donation/Autopsy Consent
brain_donation_date Brain Donation/Autopsy Consent Date
consent_form_3 Upload consent form
study_consent_form Study Consent Form
consent_date Date of consent
consent_form Upload consent form
consent_notes Notes on Consent
nacc_completed NACC forms completed?
uds UDS form uploaded to NACC? 1, Yes | 0, No
neuroexam Was a neuroexam performed? 1, Yes | 0, No
neuroexam_by Neuroexam performed by:
exam_format How was the exam conducted? 1, In-Person | 2, Virtually via Zoom
neuro_dt Date of neuroexam
cog_test Was a cognitive test performed? 1, Yes | 0, No
cog_test_by Cognitive test performed by:
cog_test_dt Date of cognitive test
fn_assessment Was a functional assessment done? 1, Yes | 0, No
fn_assessment_by Functional assessment performed by:
fn_assessment_dt Date of functional assessment
caregiver_survey Was a caregiver burden survey done? 1, Yes | 0, No
caregiver_survey_by Caregiver burden survey given by:
caregiver_survey_dt Date of caregiver burden survey
blood Was blood drawn? 1, Yes | 0, No
blood_by Blood drawn by:
blood_fast Fasting or non-fasting at blood draw? 0, non fasting | 1, fasting
blood_dt Date of blood draw
blood_tm Time of blood draw
blood_dt_lastmeal Date of last meal
blood_tm_lastmeal Time of last meal
urine Was Urine collected? 1, Yes | 0, No
urine_by Urine collected by:
urine_fast Fasting or non-fasting at urine sample? 0, non fasting | 1, fasting
urine_dt Date of urine collection
urine_tm Time of urine collection
urine_dt_lastmeal Date of last meal (urine collection)
urine_tm_lastmeal Time of last meal (urine collection)
skin_biop Was a skin biopsy taken? 1, Yes | 0, No
skin_biop_by Skin biopsy taken by:
skin_biop_dt Date of skin biopsy
skin_biop_tm Time of skin biopsy
stool was a stool sample taken? 1, Yes | 0, No
stool_by stool sample taken by:
stool_dt date of stool sample
stool_bloodkit was the additional stool and blood kit for AGMP sent? 1, Yes | 0, No
stool_by_2 Additional stool and blood kit for AGMP sent by:
date_kit Date stool and blood kit sample for AGMP was sent to participant
code_kit Code number of kit
code_kit_2 Confirm code number of kit
agmp_notes Notes:
ncrad_date Date kit was received by NCRAD
warning
Warning! Please make sure code number matches
warning_2
Code number match
agmp_received Date AGMP samples were received
actigraphy_watch Was an actigraphy watch given? 1, Yes | 0, No
actigraphy_watch_given_by Actigraphy Watch Given By
actigraphy_id Actigraphy Watch ID
actigraphy_date_given Date Actigraphy Watch was Given
actigraphy_date_received Date Actigraphy Watch was Received
oximetry_watch Was an oximetry watch given? 1, Yes | 0, No
oximetry_watch_given_by Oximetry Watch Given By
oximetry_id Oximetry Watch ID
oximetry_date_given Date Oximetry Watch was Given
oximetry_date_received Date Oximetry Watch was Received
lp_attempted Was a LP attempted?
date_lp_attempted Date LP Attempted
lp_attempt_notes LP Attempt Notes
csf was a CSF sample taken? 1, Yes | 0, No
csf_by CSF sample taken by:
csf_fast Fasting or non-fasting at CSF sample collection? 0, non fasting | 1, fasting
csf_dt Date of CSF sample
csf_tm Time of CSF sample
csf_date_lastmeal Date of last meal (CSF)
time_last_meal Time of last meal (CSF)
csf_saa_result CSF SAA Result 0, NOT DETECTED | 1, Indeterminate | 2, DETECTED
mri_sched_notes MRI scheduling Notes
mri was an MRI conducted? 1, Yes | 0, No
mri_by MRI conducted by:
mri_dt Date of MRI
pet_sched_notes PET scheduling Notes
pet_results Do you want your PET (amyloid) scan results?
pet_results_disclosed_ab Have amyloid PET results been disclosed? 1, Yes | 2, No
disclosing_adrc_faculty_ab Disclosing ADRC Faculty Member
date_of_disclosure_ab Date of Disclosure:
person_receiving_ab Person(s) Receiving Information: 1, Participant | 2, Participant Spouse/Partner | 3, Participant Child | 4, Other
other_receiving_info_ab If Other:
mode_disclosure_ab Mode(s) of Disclosure: 1, In-Person | 2, Telephone | 3, Video Conference | 4, Email/Electronic Communication | 5, Written Communication | 6, Other
other_mode_ab If Other:
pet_scan Was an Amyloid PET scan done? 1, Yes | 0, No
pet_tracer PET tracer used
pet_by Amyloid PET scan performed by:
pet_scan_dt Date of amyloid PET scan
pet_scan_tau Was a tau PET scan done? 1, Yes | 0, No
pet_by_2 Tau PET scan performed by:
pet_scan_dt_tau Date of Tau PET scan
pet_results_disclosed_tau Have Tau PET results been disclosed? 1, Yes | 2, No
gait_test Was a Gait and Balance test done? 1, Yes | 0, No
gait_test_by Gait and balance test conducted by:
gait_test_dt Date of Gait and Balance test
updrs was the UPDRS (unified parkinson's disease rating scale) measured? 1, Yes | 0, No
updrs_by UPDRS measured by:
updrs_dt Date of UPDRS
autopsy_consent Has the participant agreed to autopsy at the end of the study? 0, Do NOT agree | 1, agree
autopsy_agree_dt Date the participant responded to question about autopsy
autopsy_consent_note Autopsy consent note
visit_note General notes
additional_studies Additional Studies
consent_res_sum_letter Consent to get research summary letter
consent_res_sum_letter_dt Date the research summary letter was sent
apoe_data APOE 1, 1=e3/e3 | 2, 2=e3/e4 | 3, 3=e3/e2 | 4, 4=e4/e4 | 5, 5=e4/e2 | 6, 6=e2/e2
dna_position_num DNA data position number
dna_plate_num DNA data plate number
dna_notes DNA data notes
genetic_vars Causal Genetic Variants 10, PSEN1 | 20, PSEN2 | 30, APP | 40, TREM2 | 50, MAPT | 60, GRN | 70, FUS | 80, C9ORF72 | 90, NOTCH3 | 100, GBA | 110, LRRK2 | 120, SNCA
genetics_vars_notes Causal Genetics Vars Notes